package com;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface TestMapper {

	@Select("select 1")
	int selectOne();
	
	@Select("select * from im_chat[HASH id%10] where user_id = #{id} limit 10 #HASH")
	List<Map<String, Object>> selectChat(@Param("id") int id);
	
	
	@Select("select \"t1_[HASH id1 % 10]\" as id1,  \"t2_[HASH id2 % 8]\" as id2 #HASH")
	List<Map<String, Object>> selectVal(@Param("id1") int id1, @Param("id2") int id2);
	
}
